﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using ERP.BusinessEntities.Base;

namespace ERP.DAL.Base
{
    public interface IDBUtil
    {
        List<String> GetListTableInDatabase();

        List<String> GetListColumnNameOfTable(String strTable);

        bool CheckColumnIsExist(String strTable, String strColumn);

        String GetPrimaryKeyOnTable(String strTable);

        List<String> GetListForeignKeyOnTable(String strTable);

        KeyValuePair<String, int> GetTypeOfColumnOnTable(String strTable, String strColumn);

        String GetTableNameFromBusinessObject(BaseBusinessInfo obj);
        void CreateStroredProcedure(String strStoreProcedure);

    }
}
